﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using CRMFramework;
using System.Configuration;
using System.Data.Common;
using MySql.Data.MySqlClient;
using System.Text;

namespace CRMWeb
{
    /// <summary>
    /// Summary description for ImportAppData
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class ImportAppData : System.Web.Services.WebService
    {

        [WebMethod]
        public void getAppData()
        {
            DataTable dt = null;
            int flag = 0;
            try
            {
                dt = new DataTable();
                string constr = ConfigurationManager.ConnectionStrings["CrmConnImport"].ToString();
                DbConnection cn = new MySqlConnection(constr);
                var sbSql = new StringBuilder("SELECT application_info.*,app_personal_info.*, applicant_employment_info.*,applicant_business_info.*,applicant_credit_history.*,applicant_income_info.*,applicant_motor_vechicle.*,applicant_property_info.*,applicant_resedential_info.* FROM application_info");
                sbSql.Append(" LEFT JOIN applicant_employment_info ON application_info.application_id=applicant_employment_info.application_id");
                sbSql.Append(" LEFT JOIN applicant_business_info ON application_info.application_id=applicant_business_info.application_id");
                sbSql.Append(" LEFT JOIN app_personal_info ON application_info.application_id=app_personal_info.application_id");
                sbSql.Append(" LEFT JOIN applicant_credit_history ON application_info.application_id=applicant_credit_history.application_id");
                sbSql.Append(" LEFT JOIN applicant_income_info ON application_info.application_id=applicant_income_info.application_id");
                sbSql.Append(" LEFT JOIN applicant_motor_vechicle ON application_info.application_id=applicant_motor_vechicle.application_id");
                sbSql.Append(" LEFT JOIN applicant_property_info ON application_info.application_id=applicant_property_info.application_id");
                sbSql.Append(" LEFT JOIN applicant_resedential_info ON application_info.application_id=applicant_resedential_info.application_id");
                DbCommand cmd = new MySqlCommand(sbSql.ToString(), cn as MySqlConnection);
                DbDataAdapter da = new MySqlDataAdapter();

                cn.Open();
                da.SelectCommand = cmd;
                da.Fill(dt);
                cn.Close();

                string query = "select app_id from app_info";
                DataTable dt1 = DBhelper.ExecuteDataset(query).Tables[0];

                foreach (DataRow dr in dt.Rows)
                {
                    foreach (DataRow dr1 in dt1.Rows)
                    {
                        if (Int32.Parse(dr["application_id"].ToString()) == Int32.Parse(dr1["app_id"].ToString()))
                        {
                            flag = 1;
                        }
                    }
                    if (flag == 0)
                    {
                        var para = new[] {
                            DBhelper.SetParameter("@app_id", dr["application_id"].ToString()),
                            DBhelper.SetParameter("@app_FirstName1", dr["applicant_first_name"].ToString()),
                            DBhelper.SetParameter("@app_MiddleName1", dr["applicant_middle_name"].ToString()),
                            DBhelper.SetParameter("@app_Surname1", dr["applicant_sur_name"].ToString()),
                            DBhelper.SetParameter("@app_LoanAmount", dr["application_amount"].ToString()),
                            DBhelper.SetParameter("@app_Residency", dr["applicant_residency"].ToString()),
                            DBhelper.SetParameter("@app_Mobile1", dr["applicant_mobile"].ToString()),
                            DBhelper.SetParameter("@app_Phone1", dr["applicant_phone"].ToString()),
                            DBhelper.SetParameter("@app_EMailAddress1", dr["applicant_email_address"].ToString()),
                            DBhelper.SetParameter("@app_ResidentialAddress1", dr["applicant_resedential_address"].ToString()),
                            DBhelper.SetParameter("@app_DateOfBirth1", dr["applicant_dob"].ToString()),
                            DBhelper.SetParameter("@app_DriversLicence1", dr["applicant_drivers_license"].ToString()),
                            DBhelper.SetParameter("@app_ResidentialStatus1", dr["applicant_resendential_status"].ToString()),
                            DBhelper.SetParameter("@app_BoardingWithName1", dr["applicant_boardingwith_name"].ToString()),
                            DBhelper.SetParameter("@app_LengthOfResidenceYear1", dr["applicant_resedential_length"].ToString()),
                            DBhelper.SetParameter("@app_ResidencePeriod1", dr["applicant_resedential_period"].ToString()),
                            DBhelper.SetParameter("@app_NumberofDependant1", dr["applicant_numberof_dependent"].ToString()),
                            DBhelper.SetParameter("@app_PurposeOfLoan1", dr["application_purpose"].ToString()),
                            DBhelper.SetParameter("@app_otherpurpose", dr["application_other_purpose"].ToString()),
                            DBhelper.SetParameter("@app_PurposeSummary", dr["application_purpose_type"].ToString()),
                            DBhelper.SetParameter("@app_TypeOfEmployment1", dr["applicant_employment_type"].ToString()),
                            DBhelper.SetParameter("@app_BusinessName1", dr["applicant_business_name"].ToString()),
                            DBhelper.SetParameter("@app_Address1", dr["applicant_business_address"].ToString()),
                            DBhelper.SetParameter("@app_AbnNumber1", dr["applicant_business_abn"].ToString()),
                            DBhelper.SetParameter("@app_NatureOfBusiness1", dr["applicant_business_nature"].ToString()),
                            DBhelper.SetParameter("@app_moneydetail1", dr["applicant_business_money_details"].ToString()),
                            DBhelper.SetParameter("@app_NameOfDirectors1", dr["applicant_business_directors_name"].ToString()),
                            DBhelper.SetParameter("@app_IncomeAfterTax1", dr["applicant_income_aftertax"].ToString()),
                            DBhelper.SetParameter("@app_incomeAfterTax1Period", dr["applicant_income_aftertax_period"].ToString()),
                            DBhelper.SetParameter("@app_CentrelinkIncome1", dr["applicant_income_centrelink"].ToString()),
                            DBhelper.SetParameter("@app_OtherIncomeSpecify1", dr["applicant_income_other"].ToString()),
                            DBhelper.SetParameter("@app_RentalIncome1", dr["applicant_income_rental"].ToString()),
                            DBhelper.SetParameter("@app_TotalIncome", dr["applicant_income_total"].ToString()),
                            DBhelper.SetParameter("@app_Vehicle1Value", dr["applicant_vechicle_value"].ToString()),
                            DBhelper.SetParameter("@app_Vehicle1Payment", dr["applicant_vechicle_finance"].ToString()),
                            DBhelper.SetParameter("@app_Vehicle1Owner", dr["applicant_vechicle_owner"].ToString()),
                            DBhelper.SetParameter("@app_Property1Address", dr["applicant_property_address"].ToString()),
                            DBhelper.SetParameter("@app_Property1LandSize", dr["applicant_property_landsize"].ToString()),
                            DBhelper.SetParameter("@app_browser", dr["application_browser"].ToString()),
                            DBhelper.SetParameter("@app_ipaddress", dr["application_ipaddress"].ToString()),
                            DBhelper.SetParameter("@app_referrerName", dr["application_referrer_name"].ToString()),
                            DBhelper.SetParameter("@app_referrerCompany", dr["application_referrer_company"].ToString()),
                            DBhelper.SetParameter("@app_referrerEmail", dr["application_referrer_email"].ToString()),
                            DBhelper.SetParameter("@app_status", dr["application_status"].ToString()),
                            DBhelper.SetParameter("@app_ela", string.Empty),
                            DBhelper.SetParameter("@app_FirstName2", string.Empty),
                            DBhelper.SetParameter("@app_Surname2", string.Empty),
                            DBhelper.SetParameter("@app_Residency2", string.Empty),
                            DBhelper.SetParameter("@app_AoP",string.Empty),
                            DBhelper.SetParameter("@app_InvestmentBank_all", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue2",string.Empty),
                            DBhelper.SetParameter("@app_Property2Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property2Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_morarr1", string.Empty),
                            DBhelper.SetParameter("@app_morarr2", string.Empty),
                            DBhelper.SetParameter("@app_monarr1", string.Empty),
                            DBhelper.SetParameter("@app_monarr2", string.Empty),
                            DBhelper.SetParameter("@app_PropertyPostcode_all", string.Empty),
                            DBhelper.SetParameter("@app_Date", DateTime.Now),
                            DBhelper.SetParameter("@app_Time", DateTime.Now.TimeOfDay),
                            DBhelper.SetParameter("@app_damount", string.Empty),
                            DBhelper.SetParameter("@app_IncomeStatus", string.Empty),
                            DBhelper.SetParameter("@app_AssetStatus", string.Empty),
                            DBhelper.SetParameter("@app_CreditStatus", string.Empty),
                            DBhelper.SetParameter("@app_callstatus", string.Empty),
                            DBhelper.SetParameter("@app_emailFollowup", string.Empty),
                            DBhelper.SetParameter("@app_suburb", string.Empty),
                            DBhelper.SetParameter("@app_MortgageOwing", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgageBank", string.Empty),
                            DBhelper.SetParameter("@app_LivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardOwing", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardPayment", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardBank", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank4", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Property3Value", string.Empty),
                            DBhelper.SetParameter("@app_Property3Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property3Address", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property3State", string.Empty),
                            DBhelper.SetParameter("@app_morarr3", string.Empty),
                            DBhelper.SetParameter("@app_monarr3", string.Empty),
                            DBhelper.SetParameter("@app_Property3Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property3Type", string.Empty),
                            DBhelper.SetParameter("@app_Property3Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property3Description", string.Empty),
                            DBhelper.SetParameter("@app_Property3LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Value", string.Empty),
                            DBhelper.SetParameter("@app_Property4Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property4Address", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property4State", string.Empty),
                            DBhelper.SetParameter("@app_morarr4", string.Empty),
                            DBhelper.SetParameter("@app_monarr4", string.Empty),
                            DBhelper.SetParameter("@app_Property4Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property4Type", string.Empty),
                            DBhelper.SetParameter("@app_Property4Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property4Description", string.Empty),
                            DBhelper.SetParameter("@app_Property4LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_BikeValue1", string.Empty),
                            DBhelper.SetParameter("@app_BikeMake1", string.Empty),
                            DBhelper.SetParameter("@app_BikeModel1", string.Empty),
                            DBhelper.SetParameter("@app_BikeOwner1", string.Empty),
                            DBhelper.SetParameter("@app_BikeFinance1", string.Empty),
                            DBhelper.SetParameter("@app_BikeYear1", string.Empty),
                            DBhelper.SetParameter("@app_BikeInsurance1", string.Empty),
                            DBhelper.SetParameter("@app_GeneralForm", string.Empty),
                            DBhelper.SetParameter("@app_TotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment1", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment2", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment3", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment4", string.Empty),
                            DBhelper.SetParameter("@app_BusinessName", string.Empty),
                            DBhelper.SetParameter("@app_AbnNumber", string.Empty),
                            DBhelper.SetParameter("@app_NatureOfBusiness", string.Empty),
                            DBhelper.SetParameter("@app_Address", string.Empty),
                            DBhelper.SetParameter("@app_MoneyDetail", string.Empty),
                            DBhelper.SetParameter("@app_NameOfDirectors", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_LowestLivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_NoticeOnDBView", string.Empty),
                            DBhelper.SetParameter("@app_CorrectTotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_LVR1", string.Empty),
                            DBhelper.SetParameter("@app_LVR2", string.Empty),
                            DBhelper.SetParameter("@app_LVR3", string.Empty),
                            DBhelper.SetParameter("@app_LVR4", string.Empty),
                            DBhelper.SetParameter("@app_BoardingRentingFee", string.Empty),
                            DBhelper.SetParameter("@app_url", string.Empty),
                            DBhelper.SetParameter("@app_usbMonth", string.Empty),
                            DBhelper.SetParameter("@app_usbYear", string.Empty),
                            DBhelper.SetParameter("@app_usbCashSale", string.Empty),
                            DBhelper.SetParameter("@app_usbEftposSale", string.Empty),
                            DBhelper.SetParameter("@app_usbbizstatus", string.Empty),
                            DBhelper.SetParameter("@app_isUsb", string.Empty),
                            DBhelper.SetParameter("@app_Property5Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property5Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property5Address", string.Empty),
                            DBhelper.SetParameter("@app_Property5Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property5State", string.Empty),
                            DBhelper.SetParameter("@app_morarr5", string.Empty),
                            DBhelper.SetParameter("@app_monarr5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property5Type", string.Empty),
                            DBhelper.SetParameter("@app_Property5Description", string.Empty),
                            DBhelper.SetParameter("@app_Property5LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR5", string.Empty),
                            DBhelper.SetParameter("@app_Property6Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property6Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property6Address", string.Empty),
                            DBhelper.SetParameter("@app_Property6Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property6State", string.Empty),
                            DBhelper.SetParameter("@app_morarr6", string.Empty),
                            DBhelper.SetParameter("@app_monarr6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property6Type", string.Empty),
                            DBhelper.SetParameter("@app_Property6Description", string.Empty),
                            DBhelper.SetParameter("@app_Property6LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR6", string.Empty),
                            DBhelper.SetParameter("@app_BeneficiaryName", string.Empty),
                            DBhelper.SetParameter("@app_preappcode", string.Empty),
                            DBhelper.SetParameter("@app_WhyChooseMF", string.Empty),
                            DBhelper.SetParameter("@app_sendfrom", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding1", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding2", string.Empty),
                            DBhelper.SetParameter("@app_afterpage", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod1", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod2", string.Empty)
                            };

                        var sqlInertLoanQuety = new StringBuilder("insert into app_info(app_id,app_FirstName1,app_MiddleName1,app_Surname1,app_LoanAmount,app_Residency,app_Mobile1,");
                        sqlInertLoanQuety.Append("app_Phone1,app_EMailAddress1,app_ResidentialAddress1,app_DateOfBirth1,app_DriversLicence1,app_ResidentialStatus1,app_BoardingWithName1,");
                        sqlInertLoanQuety.Append("app_LengthOfResidenceYear1,app_ResidencePeriod1,app_NumberofDependant1,app_PurposeOfLoan1,app_otherpurpose,app_PurposeSummary,app_TypeOfEmployment1,");
                        sqlInertLoanQuety.Append("app_BusinessName1,app_Address1,app_AbnNumber1,app_NatureOfBusiness1,app_moneydetail1,app_NameOfDirectors1,app_IncomeAfterTax1,app_incomeAfterTax1Period,");
                        sqlInertLoanQuety.Append("app_CentrelinkIncome1,app_OtherIncomeSpecify1,app_RentalIncome1,app_TotalIncome,app_Vehicle1Value,app_Vehicle1Payment,app_Vehicle1Owner,app_Property1Address,");
                        sqlInertLoanQuety.Append("app_Property1LandSize,app_browser,app_ipaddress,app_referrerName,app_referrerCompany,app_referrerEmail,app_status,app_ela,app_FirstName2,app_Surname2,app_Residency2,");
                        sqlInertLoanQuety.Append("app_AoP,app_InvestmentBank_all,app_Property1Register1,app_Propery1RegValue1,app_Property1Register2,app_Propery1RegValue2,app_Property2Register1,app_Propery2RegValue1,");
                        sqlInertLoanQuety.Append("app_Property2Register2,app_Propery2RegValue2,app_Property3Register1,app_Propery3RegValue1,app_Property3Register2,app_Propery3RegValue2,app_Property4Register1,");
                        sqlInertLoanQuety.Append("app_Propery4RegValue1,app_Property4Register2,app_Propery4RegValue2,app_morarr1,app_morarr2,app_monarr1,app_monarr2,app_PropertyPostcode_all,app_Date,app_Time,");
                        sqlInertLoanQuety.Append("app_damount,app_IncomeStatus,app_AssetStatus,app_CreditStatus,app_callstatus,app_emailFollowup,app_suburb,app_MortgageOwing,app_MortgagePayment,app_MortgageBank,");
                        sqlInertLoanQuety.Append("app_LivingExpensesPayment,app_PersonalLoanOwing,app_PersonalLoanPayment,app_PersonalLoanBank,app_CarLoanOwing,app_CarLoanPayment,app_CarLoanBank,app_CreditCardOwing,");
                        sqlInertLoanQuety.Append("app_CreditCardPayment,app_CreditCardBank,app_PaydayLoanOwing,app_PaydayLoanPayment,app_PaydayLoanBank,app_OtherLoan1,app_OtherLoanOwing1,app_OtherLoanPayment1,");
                        sqlInertLoanQuety.Append("app_OtherLoanBank1,app_OtherLoan2,app_OtherLoanOwing2,app_OtherLoanPayment2,app_OtherLoanBank2,app_OtherLoan3,app_OtherLoanOwing3,app_OtherLoanPayment3,app_OtherLoanBank3,");
                        sqlInertLoanQuety.Append("app_OtherLoan4,app_OtherLoanOwing4,app_OtherLoanPayment4,app_OtherLoanBank4,app_Vehicle3Value,app_Vehicle3Owner,app_Motor3Make,app_Motor3Finance,app_Motor3Model,");
                        sqlInertLoanQuety.Append("app_Motor3Transmission,app_Motor3Year,app_Motor3Insurance,app_Vehicle4Value,app_Vehicle4Owner,app_Motor4Make,app_Motor4Finance,app_Motor4Model,app_Motor4Transmission,");
                        sqlInertLoanQuety.Append("app_Motor4Year,app_Motor4Insurance,app_Property3Value,app_Property3Payment,app_Property3Bank,app_Property3Owner,app_Property3Address,app_Property3Debt1st,app_Property3State,");
                        sqlInertLoanQuety.Append("app_morarr3,app_monarr3,app_Property3Postcode,app_Property3Debt2nd,app_Property3Type,app_Property3Caveat,app_Property3Description,app_Property3LandSize,app_Property3Bedrooms,");
                        sqlInertLoanQuety.Append("app_Property3Bathrooms,app_Property4Value,app_Property4Payment,app_Property4Bank,app_Property4Owner,app_Property4Address,app_Property4Debt1st,app_Property4State,app_morarr4,");
                        sqlInertLoanQuety.Append("app_monarr4,app_Property4Postcode,app_Property4Debt2nd,app_Property4Type,app_Property4Caveat,app_Property4Description,app_Property4LandSize,app_Property4Bedrooms,");
                        sqlInertLoanQuety.Append("app_Property4Bathrooms,app_BikeValue1,app_BikeMake1,app_BikeModel1,app_BikeOwner1,app_BikeFinance1,app_BikeYear1,app_BikeInsurance1,app_GeneralForm,app_TotalPayment,");
                        sqlInertLoanQuety.Append("app_MortgagePayment1,app_MortgagePayment2,app_MortgagePayment3,app_MortgagePayment4,app_BusinessName,app_AbnNumber,app_NatureOfBusiness,app_Address,app_MoneyDetail,");
                        sqlInertLoanQuety.Append("app_NameOfDirectors,app_Property1OtherMortgage1,app_Property1OtherMortgage2,app_Property2OtherMortgage1,app_Property2OtherMortgage2,app_Property3OtherMortgage1,");
                        sqlInertLoanQuety.Append("app_Property3OtherMortgage2,app_Property4OtherMortgage1,app_Property4OtherMortgage2,app_LowestLivingExpensesPayment,app_NoticeOnDBView,app_CorrectTotalPayment,");
                        sqlInertLoanQuety.Append("app_LVR1,app_LVR2,app_LVR3,app_LVR4,app_BoardingRentingFee,app_url,app_usbMonth,app_usbYear,app_usbCashSale,app_usbEftposSale,app_usbbizstatus,app_isUsb,app_Property5Value,");
                        sqlInertLoanQuety.Append("app_MortgagePayment5,app_Property5Bank,app_Property5Owner,app_Property5Address,app_Property5Debt1st,app_Property5OtherMortgage1,app_Property5OtherMortgage2,app_Property5State,");
                        sqlInertLoanQuety.Append("app_morarr5,app_monarr5,app_Property5Postcode,app_Property5Type,app_Property5Description,app_Property5LandSize,app_Property5Bedrooms,app_Property5Bathrooms,app_LVR5,app_Property6Value,");
                        sqlInertLoanQuety.Append("app_MortgagePayment6,app_Property6Bank,app_Property6Owner,app_Property6Address,app_Property6Debt1st,app_Property6OtherMortgage1,app_Property6OtherMortgage2,app_Property6State,app_morarr6,");
                        sqlInertLoanQuety.Append("app_monarr6,app_Property6Postcode,app_Property6Type,app_Property6Description,app_Property6LandSize,app_Property6Bedrooms,app_Property6Bathrooms,app_LVR6,app_BeneficiaryName,app_preappcode,");
                        sqlInertLoanQuety.Append("app_WhyChooseMF,app_sendfrom,app_totalOutstanding,app_totalOutstanding1,app_totalOutstanding2,app_afterpage,app_OtherIncomePeriod1,app_OtherIncomePeriod2) values(@app_id,@app_FirstName1,");
                        sqlInertLoanQuety.Append("@app_MiddleName1,@app_Surname1,@app_LoanAmount,@app_Residency,@app_Mobile1,@app_Phone1,@app_EMailAddress1,@app_ResidentialAddress1,@app_DateOfBirth1,@app_DriversLicence1,@app_ResidentialStatus1,");
                        sqlInertLoanQuety.Append("@app_BoardingWithName1,@app_LengthOfResidenceYear1,@app_ResidencePeriod1,@app_NumberofDependant1,@app_PurposeOfLoan1,@app_otherpurpose,@app_PurposeSummary,@app_TypeOfEmployment1,@app_BusinessName1,");
                        sqlInertLoanQuety.Append("@app_Address1,@app_AbnNumber1,@app_NatureOfBusiness1,@app_moneydetail1,@app_NameOfDirectors1,@app_IncomeAfterTax1,@app_incomeAfterTax1Period,@app_CentrelinkIncome1,@app_OtherIncomeSpecify1,");
                        sqlInertLoanQuety.Append("@app_RentalIncome1,@app_TotalIncome,@app_Vehicle1Value,@app_Vehicle1Payment,@app_Vehicle1Owner,@app_Property1Address,@app_Property1LandSize,@app_browser,@app_ipaddress,@app_referrerName,");
                        sqlInertLoanQuety.Append("@app_referrerCompany,@app_referrerEmail,@app_status,@app_ela,@app_FirstName2,@app_Surname2,@app_Residency2,@app_AoP,@app_InvestmentBank_all,@app_Property1Register1,@app_Propery1RegValue1,");
                        sqlInertLoanQuety.Append("@app_Property1Register2,@app_Propery1RegValue2,@app_Property2Register1,@app_Propery2RegValue1,@app_Property2Register2,@app_Propery2RegValue2,@app_Property3Register1,@app_Propery3RegValue1,");
                        sqlInertLoanQuety.Append("@app_Property3Register2,@app_Propery3RegValue2,@app_Property4Register1,@app_Propery4RegValue1,@app_Property4Register2,@app_Propery4RegValue2,@app_morarr1,@app_morarr2,@app_monarr1,@app_monarr2,");
                        sqlInertLoanQuety.Append("@app_PropertyPostcode_all,@app_Date,@app_Time,@app_damount,@app_IncomeStatus,@app_AssetStatus,@app_CreditStatus,@app_callstatus,@app_emailFollowup,@app_suburb,@app_MortgageOwing,@app_MortgagePayment,");
                        sqlInertLoanQuety.Append("@app_MortgageBank,@app_LivingExpensesPayment,@app_PersonalLoanOwing,@app_PersonalLoanPayment,@app_PersonalLoanBank,@app_CarLoanOwing,@app_CarLoanPayment,@app_CarLoanBank,@app_CreditCardOwing,");
                        sqlInertLoanQuety.Append("@app_CreditCardPayment,@app_CreditCardBank,@app_PaydayLoanOwing,@app_PaydayLoanPayment,@app_PaydayLoanBank,@app_OtherLoan1,@app_OtherLoanOwing1,@app_OtherLoanPayment1,@app_OtherLoanBank1,@app_OtherLoan2,");
                        sqlInertLoanQuety.Append("@app_OtherLoanOwing2,@app_OtherLoanPayment2,@app_OtherLoanBank2,@app_OtherLoan3,@app_OtherLoanOwing3,@app_OtherLoanPayment3,@app_OtherLoanBank3,@app_OtherLoan4,@app_OtherLoanOwing4,@app_OtherLoanPayment4,");
                        sqlInertLoanQuety.Append("@app_OtherLoanBank4,@app_Vehicle3Value,@app_Vehicle3Owner,@app_Motor3Make,@app_Motor3Finance,@app_Motor3Model,@app_Motor3Transmission,@app_Motor3Year,@app_Motor3Insurance,@app_Vehicle4Value,@app_Vehicle4Owner,");
                        sqlInertLoanQuety.Append("@app_Motor4Make,@app_Motor4Finance,@app_Motor4Model,@app_Motor4Transmission,@app_Motor4Year,@app_Motor4Insurance,@app_Property3Value,@app_Property3Payment,@app_Property3Bank,@app_Property3Owner,@app_Property3Address,");
                        sqlInertLoanQuety.Append("@app_Property3Debt1st,@app_Property3State,@app_morarr3,@app_monarr3,@app_Property3Postcode,@app_Property3Debt2nd,@app_Property3Type,@app_Property3Caveat,@app_Property3Description,@app_Property3LandSize,");
                        sqlInertLoanQuety.Append("@app_Property3Bedrooms,@app_Property3Bathrooms,@app_Property4Value,@app_Property4Payment,@app_Property4Bank,@app_Property4Owner,@app_Property4Address,@app_Property4Debt1st,@app_Property4State,@app_morarr4,");
                        sqlInertLoanQuety.Append("@app_monarr4,@app_Property4Postcode,@app_Property4Debt2nd,@app_Property4Type,@app_Property4Caveat,@app_Property4Description,@app_Property4LandSize,@app_Property4Bedrooms,@app_Property4Bathrooms,@app_BikeValue1,");
                        sqlInertLoanQuety.Append("@app_BikeMake1,@app_BikeModel1,@app_BikeOwner1,@app_BikeFinance1,@app_BikeYear1,@app_BikeInsurance1,@app_GeneralForm,@app_TotalPayment,@app_MortgagePayment1,@app_MortgagePayment2,@app_MortgagePayment3,@app_MortgagePayment4,");
                        sqlInertLoanQuety.Append("@app_BusinessName,@app_AbnNumber,@app_NatureOfBusiness,@app_Address,@app_MoneyDetail,@app_NameOfDirectors,@app_Property1OtherMortgage1,@app_Property1OtherMortgage2,@app_Property2OtherMortgage1,@app_Property2OtherMortgage2,");
                        sqlInertLoanQuety.Append("@app_Property3OtherMortgage1,@app_Property3OtherMortgage2,@app_Property4OtherMortgage1,@app_Property4OtherMortgage2,@app_LowestLivingExpensesPayment,@app_NoticeOnDBView,@app_CorrectTotalPayment,@app_LVR1,@app_LVR2,@app_LVR3,");
                        sqlInertLoanQuety.Append("@app_LVR4,@app_BoardingRentingFee,@app_url,@app_usbMonth,@app_usbYear,@app_usbCashSale,@app_usbEftposSale,@app_usbbizstatus,@app_isUsb,@app_Property5Value,@app_MortgagePayment5,@app_Property5Bank,@app_Property5Owner,");
                        sqlInertLoanQuety.Append("@app_Property5Address,@app_Property5Debt1st,@app_Property5OtherMortgage1,@app_Property5OtherMortgage2,@app_Property5State,@app_morarr5,@app_monarr5,@app_Property5Postcode,@app_Property5Type,@app_Property5Description,");
                        sqlInertLoanQuety.Append("@app_Property5LandSize,@app_Property5Bedrooms,@app_Property5Bathrooms,@app_LVR5,@app_Property6Value,@app_MortgagePayment6,@app_Property6Bank,@app_Property6Owner,@app_Property6Address,@app_Property6Debt1st,@app_Property6OtherMortgage1,");
                        sqlInertLoanQuety.Append("@app_Property6OtherMortgage2,@app_Property6State,@app_morarr6,@app_monarr6,@app_Property6Postcode,@app_Property6Type,@app_Property6Description,@app_Property6LandSize,@app_Property6Bedrooms,@app_Property6Bathrooms,@app_LVR6,");
                        sqlInertLoanQuety.Append("@app_BeneficiaryName,@app_preappcode,@app_WhyChooseMF,@app_sendfrom,@app_totalOutstanding,@app_totalOutstanding1,@app_totalOutstanding2,@app_afterpage,@app_OtherIncomePeriod1,@app_OtherIncomePeriod2)");
                        DBhelper.ExecuteNonQuery(sqlInertLoanQuety.ToString(), para);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

        [WebMethod]
        public void insertAppData(string FirstName, string MiddleName, string Surname, string LoanAmount, string Residency, string Mobile, string Phone, string EMailAddress, string ResidentialAddress, string DateOfBirth, string DriversLicence, string ResidentialStatus, string BoardingWithName, string LengthOfResidenceYear, string ResidencePeriod, string NumberofDependant, string PurposeOfLoan, string OtherPurpose, string PurposeSummary, string TypeOfEmployment, string BusinessName, string Address, string AbnNumber, string NatureOfBusiness, string MoneyDetail, string NameOfDirectors, string IncomeAfterTax, string IncomeAfterTax1Period, string CentrelinkIncome, string OtherIncomeSpecify, string RentalIncome, string TotalIncome, string Vehicle1Value, string Vehicle1Payment, string Vehicle1Owner, string Property1Address, string Property1LandSize, string Browser, string IpAddress, string ReferrerName, string ReferrerCompany, string ReferrerEmail, string Status)
        {
            try
            {
                var para = new[] {
                            DBhelper.SetParameter("@app_FirstName1", FirstName),
                            DBhelper.SetParameter("@app_MiddleName1", MiddleName),
                            DBhelper.SetParameter("@app_Surname1", Surname),
                            DBhelper.SetParameter("@app_LoanAmount", LoanAmount),
                            DBhelper.SetParameter("@app_Residency", Residency),
                            DBhelper.SetParameter("@app_Mobile1", Mobile),
                            DBhelper.SetParameter("@app_Phone1", Phone),
                            DBhelper.SetParameter("@app_EMailAddress1", EMailAddress),
                            DBhelper.SetParameter("@app_ResidentialAddress1", ResidentialAddress),
                            DBhelper.SetParameter("@app_DateOfBirth1", DateOfBirth),
                            DBhelper.SetParameter("@app_DriversLicence1", DriversLicence),
                            DBhelper.SetParameter("@app_ResidentialStatus1", ResidentialStatus),
                            DBhelper.SetParameter("@app_BoardingWithName1", BoardingWithName),
                            DBhelper.SetParameter("@app_LengthOfResidenceYear1", LengthOfResidenceYear),
                            DBhelper.SetParameter("@app_ResidencePeriod1", ResidencePeriod),
                            DBhelper.SetParameter("@app_NumberofDependant1", NumberofDependant),
                            DBhelper.SetParameter("@app_PurposeOfLoan1", PurposeOfLoan),
                            DBhelper.SetParameter("@app_otherpurpose", OtherPurpose),
                            DBhelper.SetParameter("@app_PurposeSummary", PurposeSummary),
                            DBhelper.SetParameter("@app_TypeOfEmployment1", TypeOfEmployment),
                            DBhelper.SetParameter("@app_BusinessName1", BusinessName),
                            DBhelper.SetParameter("@app_Address1", Address),
                            DBhelper.SetParameter("@app_AbnNumber1", AbnNumber),
                            DBhelper.SetParameter("@app_NatureOfBusiness1", NatureOfBusiness),
                            DBhelper.SetParameter("@app_moneydetail1", MoneyDetail),
                            DBhelper.SetParameter("@app_NameOfDirectors1", NameOfDirectors),
                            DBhelper.SetParameter("@app_IncomeAfterTax1", IncomeAfterTax),
                            DBhelper.SetParameter("@app_incomeAfterTax1Period", IncomeAfterTax1Period),
                            DBhelper.SetParameter("@app_CentrelinkIncome1", CentrelinkIncome),
                            DBhelper.SetParameter("@app_OtherIncomeSpecify1", OtherIncomeSpecify),
                            DBhelper.SetParameter("@app_RentalIncome1", RentalIncome),
                            DBhelper.SetParameter("@app_TotalIncome", TotalIncome),
                            DBhelper.SetParameter("@app_Vehicle1Value", Vehicle1Value),
                            DBhelper.SetParameter("@app_Vehicle1Payment", Vehicle1Payment),
                            DBhelper.SetParameter("@app_Vehicle1Owner", Vehicle1Owner),
                            DBhelper.SetParameter("@app_Property1Address", Property1Address),
                            DBhelper.SetParameter("@app_Property1LandSize", Property1LandSize),
                            DBhelper.SetParameter("@app_browser", Browser),
                            DBhelper.SetParameter("@app_ipaddress", IpAddress),
                            DBhelper.SetParameter("@app_referrerName", ReferrerName),
                            DBhelper.SetParameter("@app_referrerCompany", ReferrerCompany),
                            DBhelper.SetParameter("@app_referrerEmail", ReferrerEmail),
                            DBhelper.SetParameter("@app_status", Status),
                            DBhelper.SetParameter("@app_ela", string.Empty),
                            DBhelper.SetParameter("@app_FirstName2", string.Empty),
                            DBhelper.SetParameter("@app_Surname2", string.Empty),
                            DBhelper.SetParameter("@app_Residency2", string.Empty),
                            DBhelper.SetParameter("@app_AoP",string.Empty),
                            DBhelper.SetParameter("@app_InvestmentBank_all", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property1Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery1RegValue2",string.Empty),
                            DBhelper.SetParameter("@app_Property2Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property2Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery2RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property3Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery3RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register1", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue1", string.Empty),
                            DBhelper.SetParameter("@app_Property4Register2", string.Empty),
                            DBhelper.SetParameter("@app_Propery4RegValue2", string.Empty),
                            DBhelper.SetParameter("@app_morarr1", string.Empty),
                            DBhelper.SetParameter("@app_morarr2", string.Empty),
                            DBhelper.SetParameter("@app_monarr1", string.Empty),
                            DBhelper.SetParameter("@app_monarr2", string.Empty),
                            DBhelper.SetParameter("@app_PropertyPostcode_all", string.Empty),
                            DBhelper.SetParameter("@app_Date", DateTime.Now),
                            DBhelper.SetParameter("@app_Time", DateTime.Now.TimeOfDay),
                            DBhelper.SetParameter("@app_damount", string.Empty),
                            DBhelper.SetParameter("@app_IncomeStatus", string.Empty),
                            DBhelper.SetParameter("@app_AssetStatus", string.Empty),
                            DBhelper.SetParameter("@app_CreditStatus", string.Empty),
                            DBhelper.SetParameter("@app_callstatus", string.Empty),
                            DBhelper.SetParameter("@app_emailFollowup", string.Empty),
                            DBhelper.SetParameter("@app_suburb", string.Empty),
                            DBhelper.SetParameter("@app_MortgageOwing", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgageBank", string.Empty),
                            DBhelper.SetParameter("@app_LivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PersonalLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_CarLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardOwing", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardPayment", string.Empty),
                            DBhelper.SetParameter("@app_CreditCardBank", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanOwing", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanPayment", string.Empty),
                            DBhelper.SetParameter("@app_PaydayLoanBank", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank1", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank2", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank3", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoan4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanOwing4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanPayment4", string.Empty),
                            DBhelper.SetParameter("@app_OtherLoanBank4", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor3Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Value", string.Empty),
                            DBhelper.SetParameter("@app_Vehicle4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Make", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Finance", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Model", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Transmission", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Year", string.Empty),
                            DBhelper.SetParameter("@app_Motor4Insurance", string.Empty),
                            DBhelper.SetParameter("@app_Property3Value", string.Empty),
                            DBhelper.SetParameter("@app_Property3Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property3Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property3Address", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property3State", string.Empty),
                            DBhelper.SetParameter("@app_morarr3", string.Empty),
                            DBhelper.SetParameter("@app_monarr3", string.Empty),
                            DBhelper.SetParameter("@app_Property3Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property3Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property3Type", string.Empty),
                            DBhelper.SetParameter("@app_Property3Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property3Description", string.Empty),
                            DBhelper.SetParameter("@app_Property3LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property3Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Value", string.Empty),
                            DBhelper.SetParameter("@app_Property4Payment", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property4Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property4Address", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property4State", string.Empty),
                            DBhelper.SetParameter("@app_morarr4", string.Empty),
                            DBhelper.SetParameter("@app_monarr4", string.Empty),
                            DBhelper.SetParameter("@app_Property4Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property4Debt2nd", string.Empty),
                            DBhelper.SetParameter("@app_Property4Type", string.Empty),
                            DBhelper.SetParameter("@app_Property4Caveat", string.Empty),
                            DBhelper.SetParameter("@app_Property4Description", string.Empty),
                            DBhelper.SetParameter("@app_Property4LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property4Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_BikeValue1", string.Empty),
                            DBhelper.SetParameter("@app_BikeMake1", string.Empty),
                            DBhelper.SetParameter("@app_BikeModel1", string.Empty),
                            DBhelper.SetParameter("@app_BikeOwner1", string.Empty),
                            DBhelper.SetParameter("@app_BikeFinance1", string.Empty),
                            DBhelper.SetParameter("@app_BikeYear1", string.Empty),
                            DBhelper.SetParameter("@app_BikeInsurance1", string.Empty),
                            DBhelper.SetParameter("@app_GeneralForm", string.Empty),
                            DBhelper.SetParameter("@app_TotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment1", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment2", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment3", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment4", string.Empty),
                            DBhelper.SetParameter("@app_BusinessName", string.Empty),
                            DBhelper.SetParameter("@app_AbnNumber", string.Empty),
                            DBhelper.SetParameter("@app_NatureOfBusiness", string.Empty),
                            DBhelper.SetParameter("@app_Address", string.Empty),
                            DBhelper.SetParameter("@app_MoneyDetail", string.Empty),
                            DBhelper.SetParameter("@app_NameOfDirectors", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property1OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property2OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property3OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property4OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_LowestLivingExpensesPayment", string.Empty),
                            DBhelper.SetParameter("@app_NoticeOnDBView", string.Empty),
                            DBhelper.SetParameter("@app_CorrectTotalPayment", string.Empty),
                            DBhelper.SetParameter("@app_LVR1", string.Empty),
                            DBhelper.SetParameter("@app_LVR2", string.Empty),
                            DBhelper.SetParameter("@app_LVR3", string.Empty),
                            DBhelper.SetParameter("@app_LVR4", string.Empty),
                            DBhelper.SetParameter("@app_BoardingRentingFee", string.Empty),
                            DBhelper.SetParameter("@app_url", string.Empty),
                            DBhelper.SetParameter("@app_usbMonth", string.Empty),
                            DBhelper.SetParameter("@app_usbYear", string.Empty),
                            DBhelper.SetParameter("@app_usbCashSale", string.Empty),
                            DBhelper.SetParameter("@app_usbEftposSale", string.Empty),
                            DBhelper.SetParameter("@app_usbbizstatus", string.Empty),
                            DBhelper.SetParameter("@app_isUsb", string.Empty),
                            DBhelper.SetParameter("@app_Property5Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property5Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property5Address", string.Empty),
                            DBhelper.SetParameter("@app_Property5Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property5OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property5State", string.Empty),
                            DBhelper.SetParameter("@app_morarr5", string.Empty),
                            DBhelper.SetParameter("@app_monarr5", string.Empty),
                            DBhelper.SetParameter("@app_Property5Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property5Type", string.Empty),
                            DBhelper.SetParameter("@app_Property5Description", string.Empty),
                            DBhelper.SetParameter("@app_Property5LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property5Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR5", string.Empty),
                            DBhelper.SetParameter("@app_Property6Value", string.Empty),
                            DBhelper.SetParameter("@app_MortgagePayment6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bank", string.Empty),
                            DBhelper.SetParameter("@app_Property6Owner", string.Empty),
                            DBhelper.SetParameter("@app_Property6Address", string.Empty),
                            DBhelper.SetParameter("@app_Property6Debt1st", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage1", string.Empty),
                            DBhelper.SetParameter("@app_Property6OtherMortgage2", string.Empty),
                            DBhelper.SetParameter("@app_Property6State", string.Empty),
                            DBhelper.SetParameter("@app_morarr6", string.Empty),
                            DBhelper.SetParameter("@app_monarr6", string.Empty),
                            DBhelper.SetParameter("@app_Property6Postcode", string.Empty),
                            DBhelper.SetParameter("@app_Property6Type", string.Empty),
                            DBhelper.SetParameter("@app_Property6Description", string.Empty),
                            DBhelper.SetParameter("@app_Property6LandSize", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bedrooms", string.Empty),
                            DBhelper.SetParameter("@app_Property6Bathrooms", string.Empty),
                            DBhelper.SetParameter("@app_LVR6", string.Empty),
                            DBhelper.SetParameter("@app_BeneficiaryName", string.Empty),
                            DBhelper.SetParameter("@app_preappcode", string.Empty),
                            DBhelper.SetParameter("@app_WhyChooseMF", string.Empty),
                            DBhelper.SetParameter("@app_sendfrom", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding1", string.Empty),
                            DBhelper.SetParameter("@app_totalOutstanding2", string.Empty),
                            DBhelper.SetParameter("@app_afterpage", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod1", string.Empty),
                            DBhelper.SetParameter("@app_OtherIncomePeriod2", string.Empty)
                            };

                var sqlInertLoanQuety = new StringBuilder("insert into app_info(app_FirstName1,app_MiddleName1,app_Surname1,app_LoanAmount,app_Residency,app_Mobile1,");
                sqlInertLoanQuety.Append("app_Phone1,app_EMailAddress1,app_ResidentialAddress1,app_DateOfBirth1,app_DriversLicence1,app_ResidentialStatus1,app_BoardingWithName1,");
                sqlInertLoanQuety.Append("app_LengthOfResidenceYear1,app_ResidencePeriod1,app_NumberofDependant1,app_PurposeOfLoan1,app_otherpurpose,app_PurposeSummary,app_TypeOfEmployment1,");
                sqlInertLoanQuety.Append("app_BusinessName1,app_Address1,app_AbnNumber1,app_NatureOfBusiness1,app_moneydetail1,app_NameOfDirectors1,app_IncomeAfterTax1,app_incomeAfterTax1Period,");
                sqlInertLoanQuety.Append("app_CentrelinkIncome1,app_OtherIncomeSpecify1,app_RentalIncome1,app_TotalIncome,app_Vehicle1Value,app_Vehicle1Payment,app_Vehicle1Owner,app_Property1Address,");
                sqlInertLoanQuety.Append("app_Property1LandSize,app_browser,app_ipaddress,app_referrerName,app_referrerCompany,app_referrerEmail,app_status,app_ela,app_FirstName2,app_Surname2,app_Residency2,");
                sqlInertLoanQuety.Append("app_AoP,app_InvestmentBank_all,app_Property1Register1,app_Propery1RegValue1,app_Property1Register2,app_Propery1RegValue2,app_Property2Register1,app_Propery2RegValue1,");
                sqlInertLoanQuety.Append("app_Property2Register2,app_Propery2RegValue2,app_Property3Register1,app_Propery3RegValue1,app_Property3Register2,app_Propery3RegValue2,app_Property4Register1,");
                sqlInertLoanQuety.Append("app_Propery4RegValue1,app_Property4Register2,app_Propery4RegValue2,app_morarr1,app_morarr2,app_monarr1,app_monarr2,app_PropertyPostcode_all,app_Date,app_Time,");
                sqlInertLoanQuety.Append("app_damount,app_IncomeStatus,app_AssetStatus,app_CreditStatus,app_callstatus,app_emailFollowup,app_suburb,app_MortgageOwing,app_MortgagePayment,app_MortgageBank,");
                sqlInertLoanQuety.Append("app_LivingExpensesPayment,app_PersonalLoanOwing,app_PersonalLoanPayment,app_PersonalLoanBank,app_CarLoanOwing,app_CarLoanPayment,app_CarLoanBank,app_CreditCardOwing,");
                sqlInertLoanQuety.Append("app_CreditCardPayment,app_CreditCardBank,app_PaydayLoanOwing,app_PaydayLoanPayment,app_PaydayLoanBank,app_OtherLoan1,app_OtherLoanOwing1,app_OtherLoanPayment1,");
                sqlInertLoanQuety.Append("app_OtherLoanBank1,app_OtherLoan2,app_OtherLoanOwing2,app_OtherLoanPayment2,app_OtherLoanBank2,app_OtherLoan3,app_OtherLoanOwing3,app_OtherLoanPayment3,app_OtherLoanBank3,");
                sqlInertLoanQuety.Append("app_OtherLoan4,app_OtherLoanOwing4,app_OtherLoanPayment4,app_OtherLoanBank4,app_Vehicle3Value,app_Vehicle3Owner,app_Motor3Make,app_Motor3Finance,app_Motor3Model,");
                sqlInertLoanQuety.Append("app_Motor3Transmission,app_Motor3Year,app_Motor3Insurance,app_Vehicle4Value,app_Vehicle4Owner,app_Motor4Make,app_Motor4Finance,app_Motor4Model,app_Motor4Transmission,");
                sqlInertLoanQuety.Append("app_Motor4Year,app_Motor4Insurance,app_Property3Value,app_Property3Payment,app_Property3Bank,app_Property3Owner,app_Property3Address,app_Property3Debt1st,app_Property3State,");
                sqlInertLoanQuety.Append("app_morarr3,app_monarr3,app_Property3Postcode,app_Property3Debt2nd,app_Property3Type,app_Property3Caveat,app_Property3Description,app_Property3LandSize,app_Property3Bedrooms,");
                sqlInertLoanQuety.Append("app_Property3Bathrooms,app_Property4Value,app_Property4Payment,app_Property4Bank,app_Property4Owner,app_Property4Address,app_Property4Debt1st,app_Property4State,app_morarr4,");
                sqlInertLoanQuety.Append("app_monarr4,app_Property4Postcode,app_Property4Debt2nd,app_Property4Type,app_Property4Caveat,app_Property4Description,app_Property4LandSize,app_Property4Bedrooms,");
                sqlInertLoanQuety.Append("app_Property4Bathrooms,app_BikeValue1,app_BikeMake1,app_BikeModel1,app_BikeOwner1,app_BikeFinance1,app_BikeYear1,app_BikeInsurance1,app_GeneralForm,app_TotalPayment,");
                sqlInertLoanQuety.Append("app_MortgagePayment1,app_MortgagePayment2,app_MortgagePayment3,app_MortgagePayment4,app_BusinessName,app_AbnNumber,app_NatureOfBusiness,app_Address,app_MoneyDetail,");
                sqlInertLoanQuety.Append("app_NameOfDirectors,app_Property1OtherMortgage1,app_Property1OtherMortgage2,app_Property2OtherMortgage1,app_Property2OtherMortgage2,app_Property3OtherMortgage1,");
                sqlInertLoanQuety.Append("app_Property3OtherMortgage2,app_Property4OtherMortgage1,app_Property4OtherMortgage2,app_LowestLivingExpensesPayment,app_NoticeOnDBView,app_CorrectTotalPayment,");
                sqlInertLoanQuety.Append("app_LVR1,app_LVR2,app_LVR3,app_LVR4,app_BoardingRentingFee,app_url,app_usbMonth,app_usbYear,app_usbCashSale,app_usbEftposSale,app_usbbizstatus,app_isUsb,app_Property5Value,");
                sqlInertLoanQuety.Append("app_MortgagePayment5,app_Property5Bank,app_Property5Owner,app_Property5Address,app_Property5Debt1st,app_Property5OtherMortgage1,app_Property5OtherMortgage2,app_Property5State,");
                sqlInertLoanQuety.Append("app_morarr5,app_monarr5,app_Property5Postcode,app_Property5Type,app_Property5Description,app_Property5LandSize,app_Property5Bedrooms,app_Property5Bathrooms,app_LVR5,app_Property6Value,");
                sqlInertLoanQuety.Append("app_MortgagePayment6,app_Property6Bank,app_Property6Owner,app_Property6Address,app_Property6Debt1st,app_Property6OtherMortgage1,app_Property6OtherMortgage2,app_Property6State,app_morarr6,");
                sqlInertLoanQuety.Append("app_monarr6,app_Property6Postcode,app_Property6Type,app_Property6Description,app_Property6LandSize,app_Property6Bedrooms,app_Property6Bathrooms,app_LVR6,app_BeneficiaryName,app_preappcode,");
                sqlInertLoanQuety.Append("app_WhyChooseMF,app_sendfrom,app_totalOutstanding,app_totalOutstanding1,app_totalOutstanding2,app_afterpage,app_OtherIncomePeriod1,app_OtherIncomePeriod2) values(@app_FirstName1,");
                sqlInertLoanQuety.Append("@app_MiddleName1,@app_Surname1,@app_LoanAmount,@app_Residency,@app_Mobile1,@app_Phone1,@app_EMailAddress1,@app_ResidentialAddress1,@app_DateOfBirth1,@app_DriversLicence1,@app_ResidentialStatus1,");
                sqlInertLoanQuety.Append("@app_BoardingWithName1,@app_LengthOfResidenceYear1,@app_ResidencePeriod1,@app_NumberofDependant1,@app_PurposeOfLoan1,@app_otherpurpose,@app_PurposeSummary,@app_TypeOfEmployment1,@app_BusinessName1,");
                sqlInertLoanQuety.Append("@app_Address1,@app_AbnNumber1,@app_NatureOfBusiness1,@app_moneydetail1,@app_NameOfDirectors1,@app_IncomeAfterTax1,@app_incomeAfterTax1Period,@app_CentrelinkIncome1,@app_OtherIncomeSpecify1,");
                sqlInertLoanQuety.Append("@app_RentalIncome1,@app_TotalIncome,@app_Vehicle1Value,@app_Vehicle1Payment,@app_Vehicle1Owner,@app_Property1Address,@app_Property1LandSize,@app_browser,@app_ipaddress,@app_referrerName,");
                sqlInertLoanQuety.Append("@app_referrerCompany,@app_referrerEmail,@app_status,@app_ela,@app_FirstName2,@app_Surname2,@app_Residency2,@app_AoP,@app_InvestmentBank_all,@app_Property1Register1,@app_Propery1RegValue1,");
                sqlInertLoanQuety.Append("@app_Property1Register2,@app_Propery1RegValue2,@app_Property2Register1,@app_Propery2RegValue1,@app_Property2Register2,@app_Propery2RegValue2,@app_Property3Register1,@app_Propery3RegValue1,");
                sqlInertLoanQuety.Append("@app_Property3Register2,@app_Propery3RegValue2,@app_Property4Register1,@app_Propery4RegValue1,@app_Property4Register2,@app_Propery4RegValue2,@app_morarr1,@app_morarr2,@app_monarr1,@app_monarr2,");
                sqlInertLoanQuety.Append("@app_PropertyPostcode_all,@app_Date,@app_Time,@app_damount,@app_IncomeStatus,@app_AssetStatus,@app_CreditStatus,@app_callstatus,@app_emailFollowup,@app_suburb,@app_MortgageOwing,@app_MortgagePayment,");
                sqlInertLoanQuety.Append("@app_MortgageBank,@app_LivingExpensesPayment,@app_PersonalLoanOwing,@app_PersonalLoanPayment,@app_PersonalLoanBank,@app_CarLoanOwing,@app_CarLoanPayment,@app_CarLoanBank,@app_CreditCardOwing,");
                sqlInertLoanQuety.Append("@app_CreditCardPayment,@app_CreditCardBank,@app_PaydayLoanOwing,@app_PaydayLoanPayment,@app_PaydayLoanBank,@app_OtherLoan1,@app_OtherLoanOwing1,@app_OtherLoanPayment1,@app_OtherLoanBank1,@app_OtherLoan2,");
                sqlInertLoanQuety.Append("@app_OtherLoanOwing2,@app_OtherLoanPayment2,@app_OtherLoanBank2,@app_OtherLoan3,@app_OtherLoanOwing3,@app_OtherLoanPayment3,@app_OtherLoanBank3,@app_OtherLoan4,@app_OtherLoanOwing4,@app_OtherLoanPayment4,");
                sqlInertLoanQuety.Append("@app_OtherLoanBank4,@app_Vehicle3Value,@app_Vehicle3Owner,@app_Motor3Make,@app_Motor3Finance,@app_Motor3Model,@app_Motor3Transmission,@app_Motor3Year,@app_Motor3Insurance,@app_Vehicle4Value,@app_Vehicle4Owner,");
                sqlInertLoanQuety.Append("@app_Motor4Make,@app_Motor4Finance,@app_Motor4Model,@app_Motor4Transmission,@app_Motor4Year,@app_Motor4Insurance,@app_Property3Value,@app_Property3Payment,@app_Property3Bank,@app_Property3Owner,@app_Property3Address,");
                sqlInertLoanQuety.Append("@app_Property3Debt1st,@app_Property3State,@app_morarr3,@app_monarr3,@app_Property3Postcode,@app_Property3Debt2nd,@app_Property3Type,@app_Property3Caveat,@app_Property3Description,@app_Property3LandSize,");
                sqlInertLoanQuety.Append("@app_Property3Bedrooms,@app_Property3Bathrooms,@app_Property4Value,@app_Property4Payment,@app_Property4Bank,@app_Property4Owner,@app_Property4Address,@app_Property4Debt1st,@app_Property4State,@app_morarr4,");
                sqlInertLoanQuety.Append("@app_monarr4,@app_Property4Postcode,@app_Property4Debt2nd,@app_Property4Type,@app_Property4Caveat,@app_Property4Description,@app_Property4LandSize,@app_Property4Bedrooms,@app_Property4Bathrooms,@app_BikeValue1,");
                sqlInertLoanQuety.Append("@app_BikeMake1,@app_BikeModel1,@app_BikeOwner1,@app_BikeFinance1,@app_BikeYear1,@app_BikeInsurance1,@app_GeneralForm,@app_TotalPayment,@app_MortgagePayment1,@app_MortgagePayment2,@app_MortgagePayment3,@app_MortgagePayment4,");
                sqlInertLoanQuety.Append("@app_BusinessName,@app_AbnNumber,@app_NatureOfBusiness,@app_Address,@app_MoneyDetail,@app_NameOfDirectors,@app_Property1OtherMortgage1,@app_Property1OtherMortgage2,@app_Property2OtherMortgage1,@app_Property2OtherMortgage2,");
                sqlInertLoanQuety.Append("@app_Property3OtherMortgage1,@app_Property3OtherMortgage2,@app_Property4OtherMortgage1,@app_Property4OtherMortgage2,@app_LowestLivingExpensesPayment,@app_NoticeOnDBView,@app_CorrectTotalPayment,@app_LVR1,@app_LVR2,@app_LVR3,");
                sqlInertLoanQuety.Append("@app_LVR4,@app_BoardingRentingFee,@app_url,@app_usbMonth,@app_usbYear,@app_usbCashSale,@app_usbEftposSale,@app_usbbizstatus,@app_isUsb,@app_Property5Value,@app_MortgagePayment5,@app_Property5Bank,@app_Property5Owner,");
                sqlInertLoanQuety.Append("@app_Property5Address,@app_Property5Debt1st,@app_Property5OtherMortgage1,@app_Property5OtherMortgage2,@app_Property5State,@app_morarr5,@app_monarr5,@app_Property5Postcode,@app_Property5Type,@app_Property5Description,");
                sqlInertLoanQuety.Append("@app_Property5LandSize,@app_Property5Bedrooms,@app_Property5Bathrooms,@app_LVR5,@app_Property6Value,@app_MortgagePayment6,@app_Property6Bank,@app_Property6Owner,@app_Property6Address,@app_Property6Debt1st,@app_Property6OtherMortgage1,");
                sqlInertLoanQuety.Append("@app_Property6OtherMortgage2,@app_Property6State,@app_morarr6,@app_monarr6,@app_Property6Postcode,@app_Property6Type,@app_Property6Description,@app_Property6LandSize,@app_Property6Bedrooms,@app_Property6Bathrooms,@app_LVR6,");
                sqlInertLoanQuety.Append("@app_BeneficiaryName,@app_preappcode,@app_WhyChooseMF,@app_sendfrom,@app_totalOutstanding,@app_totalOutstanding1,@app_totalOutstanding2,@app_afterpage,@app_OtherIncomePeriod1,@app_OtherIncomePeriod2)");
                DBhelper.ExecuteNonQuery(sqlInertLoanQuety.ToString(), para);
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}
